package com.ourteam.education.dao;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;
import org.apache.commons.lang.StringUtils;
/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2019-09-22 15:15:08
  * Warning ! This file will be overwrite when regenerate !
  * 
 */
public class CampusDAOQueryBean extends BaseQueryBean {
    
    public CampusDAOQueryBean() {
		super();
    }
	
    public CampusDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }
    
    public CampusDAOQueryBean(BaseQueryBean aQueryBean,Map tableReplaceMap) {
        super(aQueryBean,tableReplaceMap);
    }
    
    public Criteria createCriteria() {
        
	    Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
                  oredCriteria.add(criteria);
            }
        return criteria;
     }
	
    protected Criteria createCriteriaInternal() {
	  return new Criteria(this);
    }
    
        
        
    	
		
	    
    public void addIdSelectProperty(){
		addIdSelectProperty("id");
	}
	
    public void addIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICampusDAO.Id,aAlias);
		}
		else{
			addSelectProperty(ICampusDAO.Id,"id");
	    }
    }
    
       
		
		
	    
    public void addCampusNameSelectProperty(){
		addCampusNameSelectProperty("campusName");
	}
	
    public void addCampusNameSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICampusDAO.CampusName,aAlias);
		}
		else{
			addSelectProperty(ICampusDAO.CampusName,"campusName");
	    }
    }
    
       
		
		
	    
    public void addCampusTel1SelectProperty(){
		addCampusTel1SelectProperty("campusTel1");
	}
	
    public void addCampusTel1SelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICampusDAO.CampusTel1,aAlias);
		}
		else{
			addSelectProperty(ICampusDAO.CampusTel1,"campusTel1");
	    }
    }
    
       
		
		
	    
    public void addCampusTel2SelectProperty(){
		addCampusTel2SelectProperty("campusTel2");
	}
	
    public void addCampusTel2SelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICampusDAO.CampusTel2,aAlias);
		}
		else{
			addSelectProperty(ICampusDAO.CampusTel2,"campusTel2");
	    }
    }
    
       
		
		
	    
    public void addCampusAddressSelectProperty(){
		addCampusAddressSelectProperty("campusAddress");
	}
	
    public void addCampusAddressSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICampusDAO.CampusAddress,aAlias);
		}
		else{
			addSelectProperty(ICampusDAO.CampusAddress,"campusAddress");
	    }
    }
    
       
		
		
	    
    public void addCampusTypeSelectProperty(){
		addCampusTypeSelectProperty("campusType");
	}
	
    public void addCampusTypeSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICampusDAO.CampusType,aAlias);
		}
		else{
			addSelectProperty(ICampusDAO.CampusType,"campusType");
	    }
    }
    
       
		
		
	    
    public void addSortIndexSelectProperty(){
		addSortIndexSelectProperty("sortIndex");
	}
	
    public void addSortIndexSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICampusDAO.SortIndex,aAlias);
		}
		else{
			addSelectProperty(ICampusDAO.SortIndex,"sortIndex");
	    }
    }
    
       
		
		
	    
    public void addStatusSelectProperty(){
		addStatusSelectProperty("status");
	}
	
    public void addStatusSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICampusDAO.Status,aAlias);
		}
		else{
			addSelectProperty(ICampusDAO.Status,"status");
	    }
    }
    
       
		
		
	    
    public void addRemarksSelectProperty(){
		addRemarksSelectProperty("remarks");
	}
	
    public void addRemarksSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICampusDAO.Remarks,aAlias);
		}
		else{
			addSelectProperty(ICampusDAO.Remarks,"remarks");
	    }
    }
    
       
		
		
	    
    public void addDeleteFlagSelectProperty(){
		addDeleteFlagSelectProperty("deleteFlag");
	}
	
    public void addDeleteFlagSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(ICampusDAO.DeleteFlag,aAlias);
		}
		else{
			addSelectProperty(ICampusDAO.DeleteFlag,"deleteFlag");
	    }
    }
    
       
		
		
	public void addAllSelectProperties(){
		
		
	    addIdSelectProperty();
   
		
		
	    addCampusNameSelectProperty();
   
		
		
	    addCampusTel1SelectProperty();
   
		
		
	    addCampusTel2SelectProperty();
   
		
		
	    addCampusAddressSelectProperty();
   
		
		
	    addCampusTypeSelectProperty();
   
		
		
	    addSortIndexSelectProperty();
   
		
		
	    addStatusSelectProperty();
   
		
		
	    addRemarksSelectProperty();
   
		
		
	    addDeleteFlagSelectProperty();
   
		
	    }
    
    public static class Criteria extends BaseWhereCriterion<CampusDAOQueryBean> {
	
        protected Criteria(CampusDAOQueryBean aParentObject) {
		    super(aParentObject);
        }
        
                  
            	
    	    	
    	        
                
        public Criteria andIdIsNull() {
            addCriterion(ICampusDAO.Id + " is null");
            return this;
        }
        public Criteria andIdIsNotNull() {
            addCriterion(ICampusDAO.Id + " is not null");
            return this;
        }
    
        public Criteria andIdIsNotEmpty() {        
            addCriterion(ICampusDAO.Id + " is not null AND " + ICampusDAO.Id + " <> ''");
            return this;
        }
    		
    	public Criteria andIdIsEmpty() {       
            addCriterion("(" + ICampusDAO.Id + " is null OR " + ICampusDAO.Id + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andIdEqualTo(long value) {
        	return andIdEqualTo(Long.valueOf(value));
        }
               public Criteria andIdEqualTo(java.lang.Long value) {
        				
            addCriterion(ICampusDAO.Id + " = ", value, "id");
            return this;
        }
        
        public Criteria andIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.Id);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Id + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andIdNotEqualTo(long value) {
        	return andIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(ICampusDAO.Id + " <>", value, "id");
            return this;
        }
               
        public Criteria andIdNotEqualToOrIsNull(long value) {
        	return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(ICampusDAO.Id + " is null OR " + ICampusDAO.Id + " <>", value, "id");
            return this;
        }
        
        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.Id);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Id + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThan(long value) {
        	return andIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(ICampusDAO.Id + " >", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.Id);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Id + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThanOrEqualTo(long value) {
        	return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICampusDAO.Id + " >=", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.Id);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Id + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThan(long value) {
        	return andIdLessThan(Long.valueOf(value));
        }
                public Criteria andIdLessThan(java.lang.Long value) {
        				
            addCriterion(ICampusDAO.Id + " <", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.Id);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Id + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThanOrEqualTo(long value) {
        	return andIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICampusDAO.Id + " <=", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.Id);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Id + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andIdIn(long[] values) {
        	if(values.length == 1){
        		return andIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.Id + " in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
                public Criteria andIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.Id + " in", values, "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.Id + " in", Arrays.asList(values), "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.Id + " not in", Arrays.asList(values), "id");
            	return this;
            }
        }
		
		public Criteria andIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Id + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Id + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdBetween(long value1,long value2) {
        	addCriterion(ICampusDAO.Id + " between", value1, value2, "id");
            return this;
        }
                public Criteria andIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICampusDAO.Id + " between", value1, value2, "id");
            return this;
        }
        
                
        public Criteria andIdNotBetween(long value1,long value2) {
        	addCriterion(ICampusDAO.Id + " not between", value1, value2, "id");
            return this;
        }
                public Criteria andIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICampusDAO.Id + " not between", value1, value2, "id");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andCampusNameIsNull() {
            addCriterion(ICampusDAO.CampusName + " is null");
            return this;
        }
        public Criteria andCampusNameIsNotNull() {
            addCriterion(ICampusDAO.CampusName + " is not null");
            return this;
        }
    
        public Criteria andCampusNameIsNotEmpty() {        
            addCriterion(ICampusDAO.CampusName + " is not null AND " + ICampusDAO.CampusName + " <> ''");
            return this;
        }
    		
    	public Criteria andCampusNameIsEmpty() {       
            addCriterion("(" + ICampusDAO.CampusName + " is null OR " + ICampusDAO.CampusName + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andCampusNameEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusName + " = ", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusName);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusName + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andCampusNameNotEqualTo(String value) {
        	        
            addCriterion(ICampusDAO.CampusName + " <>", value, "campusName");
            return this;
        }
               
        public Criteria andCampusNameNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICampusDAO.CampusName + " is null OR " + ICampusDAO.CampusName + " <>", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusName);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusName + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusNameGreaterThan(String value) {
        				
            addCriterion(ICampusDAO.CampusName + " >", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusName);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusName + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusNameGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusName + " >=", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusName);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusName + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusNameLessThan(String value) {
        				
            addCriterion(ICampusDAO.CampusName + " <", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusName);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusName + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusNameLessThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusName + " <=", value, "campusName");
            return this;
        }
        
        public Criteria andCampusNameLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusName);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusNameLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusName + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andCampusNameLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.CampusName + " like", buffer.toString(), "campusName");
            return this;
        }
        public Criteria andCampusNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.CampusName + " not like", buffer.toString(), "campusName");
            return this;
        }
                
                public Criteria andCampusNameIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andCampusNameEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.CampusName + " in", values, "campusName");
            	return this;
            }
        }
        public Criteria andCampusNameNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andCampusNameNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.CampusName + " not in", values, "campusName");
            	return this;
            }
        }
        
        public Criteria andCampusNameIn(String[] values) {
        	
        	if(values.length == 1){
        		return andCampusNameEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.CampusName + " in", Arrays.asList(values), "campusName");
            	return this;
            }
        }
        public Criteria andCampusNameNotIn(String[] values) {
        	if(values.length == 1){
        		return andCampusNameNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.CampusName + " not in", Arrays.asList(values), "campusName");
            	return this;
            }
        }
		
		public Criteria andCampusNameIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusName + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andCampusNameNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusName + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusNameBetween(String value1, String value2) {
            addCriterion(ICampusDAO.CampusName + " between", value1, value2, "campusName");
            return this;
        }
        
                public Criteria andCampusNameNotBetween(String value1, String value2) {
            addCriterion(ICampusDAO.CampusName + " not between", value1, value2, "campusName");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andCampusTel1IsNull() {
            addCriterion(ICampusDAO.CampusTel1 + " is null");
            return this;
        }
        public Criteria andCampusTel1IsNotNull() {
            addCriterion(ICampusDAO.CampusTel1 + " is not null");
            return this;
        }
    
        public Criteria andCampusTel1IsNotEmpty() {        
            addCriterion(ICampusDAO.CampusTel1 + " is not null AND " + ICampusDAO.CampusTel1 + " <> ''");
            return this;
        }
    		
    	public Criteria andCampusTel1IsEmpty() {       
            addCriterion("(" + ICampusDAO.CampusTel1 + " is null OR " + ICampusDAO.CampusTel1 + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andCampusTel1EqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusTel1 + " = ", value, "campusTel1");
            return this;
        }
        
        public Criteria andCampusTel1EqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusTel1);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel1EqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel1 + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andCampusTel1NotEqualTo(String value) {
        	        
            addCriterion(ICampusDAO.CampusTel1 + " <>", value, "campusTel1");
            return this;
        }
               
        public Criteria andCampusTel1NotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICampusDAO.CampusTel1 + " is null OR " + ICampusDAO.CampusTel1 + " <>", value, "campusTel1");
            return this;
        }
        
        public Criteria andCampusTel1NotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusTel1);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel1NotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel1 + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusTel1GreaterThan(String value) {
        				
            addCriterion(ICampusDAO.CampusTel1 + " >", value, "campusTel1");
            return this;
        }
        
        public Criteria andCampusTel1GreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusTel1);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel1GreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel1 + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusTel1GreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusTel1 + " >=", value, "campusTel1");
            return this;
        }
        
        public Criteria andCampusTel1GreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusTel1);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel1GreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel1 + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusTel1LessThan(String value) {
        				
            addCriterion(ICampusDAO.CampusTel1 + " <", value, "campusTel1");
            return this;
        }
        
        public Criteria andCampusTel1LessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusTel1);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel1LessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel1 + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusTel1LessThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusTel1 + " <=", value, "campusTel1");
            return this;
        }
        
        public Criteria andCampusTel1LessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusTel1);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel1LessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel1 + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andCampusTel1Like(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.CampusTel1 + " like", buffer.toString(), "campusTel1");
            return this;
        }
        public Criteria andCampusTel1NotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.CampusTel1 + " not like", buffer.toString(), "campusTel1");
            return this;
        }
                
                public Criteria andCampusTel1In(List<String> values) {
        	
        	if(values.size() == 1){
        		return andCampusTel1EqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.CampusTel1 + " in", values, "campusTel1");
            	return this;
            }
        }
        public Criteria andCampusTel1NotIn(List<String> values) {
        	if(values.size() == 1){
        		return andCampusTel1NotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.CampusTel1 + " not in", values, "campusTel1");
            	return this;
            }
        }
        
        public Criteria andCampusTel1In(String[] values) {
        	
        	if(values.length == 1){
        		return andCampusTel1EqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.CampusTel1 + " in", Arrays.asList(values), "campusTel1");
            	return this;
            }
        }
        public Criteria andCampusTel1NotIn(String[] values) {
        	if(values.length == 1){
        		return andCampusTel1NotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.CampusTel1 + " not in", Arrays.asList(values), "campusTel1");
            	return this;
            }
        }
		
		public Criteria andCampusTel1In(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel1 + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andCampusTel1NotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel1 + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusTel1Between(String value1, String value2) {
            addCriterion(ICampusDAO.CampusTel1 + " between", value1, value2, "campusTel1");
            return this;
        }
        
                public Criteria andCampusTel1NotBetween(String value1, String value2) {
            addCriterion(ICampusDAO.CampusTel1 + " not between", value1, value2, "campusTel1");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andCampusTel2IsNull() {
            addCriterion(ICampusDAO.CampusTel2 + " is null");
            return this;
        }
        public Criteria andCampusTel2IsNotNull() {
            addCriterion(ICampusDAO.CampusTel2 + " is not null");
            return this;
        }
    
        public Criteria andCampusTel2IsNotEmpty() {        
            addCriterion(ICampusDAO.CampusTel2 + " is not null AND " + ICampusDAO.CampusTel2 + " <> ''");
            return this;
        }
    		
    	public Criteria andCampusTel2IsEmpty() {       
            addCriterion("(" + ICampusDAO.CampusTel2 + " is null OR " + ICampusDAO.CampusTel2 + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andCampusTel2EqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusTel2 + " = ", value, "campusTel2");
            return this;
        }
        
        public Criteria andCampusTel2EqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusTel2);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel2EqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel2 + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andCampusTel2NotEqualTo(String value) {
        	        
            addCriterion(ICampusDAO.CampusTel2 + " <>", value, "campusTel2");
            return this;
        }
               
        public Criteria andCampusTel2NotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICampusDAO.CampusTel2 + " is null OR " + ICampusDAO.CampusTel2 + " <>", value, "campusTel2");
            return this;
        }
        
        public Criteria andCampusTel2NotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusTel2);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel2NotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel2 + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusTel2GreaterThan(String value) {
        				
            addCriterion(ICampusDAO.CampusTel2 + " >", value, "campusTel2");
            return this;
        }
        
        public Criteria andCampusTel2GreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusTel2);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel2GreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel2 + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusTel2GreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusTel2 + " >=", value, "campusTel2");
            return this;
        }
        
        public Criteria andCampusTel2GreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusTel2);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel2GreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel2 + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusTel2LessThan(String value) {
        				
            addCriterion(ICampusDAO.CampusTel2 + " <", value, "campusTel2");
            return this;
        }
        
        public Criteria andCampusTel2LessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusTel2);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel2LessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel2 + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusTel2LessThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusTel2 + " <=", value, "campusTel2");
            return this;
        }
        
        public Criteria andCampusTel2LessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusTel2);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTel2LessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel2 + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andCampusTel2Like(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.CampusTel2 + " like", buffer.toString(), "campusTel2");
            return this;
        }
        public Criteria andCampusTel2NotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.CampusTel2 + " not like", buffer.toString(), "campusTel2");
            return this;
        }
                
                public Criteria andCampusTel2In(List<String> values) {
        	
        	if(values.size() == 1){
        		return andCampusTel2EqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.CampusTel2 + " in", values, "campusTel2");
            	return this;
            }
        }
        public Criteria andCampusTel2NotIn(List<String> values) {
        	if(values.size() == 1){
        		return andCampusTel2NotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.CampusTel2 + " not in", values, "campusTel2");
            	return this;
            }
        }
        
        public Criteria andCampusTel2In(String[] values) {
        	
        	if(values.length == 1){
        		return andCampusTel2EqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.CampusTel2 + " in", Arrays.asList(values), "campusTel2");
            	return this;
            }
        }
        public Criteria andCampusTel2NotIn(String[] values) {
        	if(values.length == 1){
        		return andCampusTel2NotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.CampusTel2 + " not in", Arrays.asList(values), "campusTel2");
            	return this;
            }
        }
		
		public Criteria andCampusTel2In(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel2 + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andCampusTel2NotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusTel2 + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusTel2Between(String value1, String value2) {
            addCriterion(ICampusDAO.CampusTel2 + " between", value1, value2, "campusTel2");
            return this;
        }
        
                public Criteria andCampusTel2NotBetween(String value1, String value2) {
            addCriterion(ICampusDAO.CampusTel2 + " not between", value1, value2, "campusTel2");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andCampusAddressIsNull() {
            addCriterion(ICampusDAO.CampusAddress + " is null");
            return this;
        }
        public Criteria andCampusAddressIsNotNull() {
            addCriterion(ICampusDAO.CampusAddress + " is not null");
            return this;
        }
    
        public Criteria andCampusAddressIsNotEmpty() {        
            addCriterion(ICampusDAO.CampusAddress + " is not null AND " + ICampusDAO.CampusAddress + " <> ''");
            return this;
        }
    		
    	public Criteria andCampusAddressIsEmpty() {       
            addCriterion("(" + ICampusDAO.CampusAddress + " is null OR " + ICampusDAO.CampusAddress + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andCampusAddressEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusAddress + " = ", value, "campusAddress");
            return this;
        }
        
        public Criteria andCampusAddressEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusAddress);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusAddressEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusAddress + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andCampusAddressNotEqualTo(String value) {
        	        
            addCriterion(ICampusDAO.CampusAddress + " <>", value, "campusAddress");
            return this;
        }
               
        public Criteria andCampusAddressNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICampusDAO.CampusAddress + " is null OR " + ICampusDAO.CampusAddress + " <>", value, "campusAddress");
            return this;
        }
        
        public Criteria andCampusAddressNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusAddress);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusAddressNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusAddress + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusAddressGreaterThan(String value) {
        				
            addCriterion(ICampusDAO.CampusAddress + " >", value, "campusAddress");
            return this;
        }
        
        public Criteria andCampusAddressGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusAddress);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusAddressGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusAddress + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusAddressGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusAddress + " >=", value, "campusAddress");
            return this;
        }
        
        public Criteria andCampusAddressGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusAddress);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusAddressGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusAddress + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusAddressLessThan(String value) {
        				
            addCriterion(ICampusDAO.CampusAddress + " <", value, "campusAddress");
            return this;
        }
        
        public Criteria andCampusAddressLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusAddress);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusAddressLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusAddress + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusAddressLessThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusAddress + " <=", value, "campusAddress");
            return this;
        }
        
        public Criteria andCampusAddressLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusAddress);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusAddressLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusAddress + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andCampusAddressLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.CampusAddress + " like", buffer.toString(), "campusAddress");
            return this;
        }
        public Criteria andCampusAddressNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.CampusAddress + " not like", buffer.toString(), "campusAddress");
            return this;
        }
                
                public Criteria andCampusAddressIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andCampusAddressEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.CampusAddress + " in", values, "campusAddress");
            	return this;
            }
        }
        public Criteria andCampusAddressNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andCampusAddressNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.CampusAddress + " not in", values, "campusAddress");
            	return this;
            }
        }
        
        public Criteria andCampusAddressIn(String[] values) {
        	
        	if(values.length == 1){
        		return andCampusAddressEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.CampusAddress + " in", Arrays.asList(values), "campusAddress");
            	return this;
            }
        }
        public Criteria andCampusAddressNotIn(String[] values) {
        	if(values.length == 1){
        		return andCampusAddressNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.CampusAddress + " not in", Arrays.asList(values), "campusAddress");
            	return this;
            }
        }
		
		public Criteria andCampusAddressIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusAddress + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andCampusAddressNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusAddress + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusAddressBetween(String value1, String value2) {
            addCriterion(ICampusDAO.CampusAddress + " between", value1, value2, "campusAddress");
            return this;
        }
        
                public Criteria andCampusAddressNotBetween(String value1, String value2) {
            addCriterion(ICampusDAO.CampusAddress + " not between", value1, value2, "campusAddress");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andCampusTypeIsNull() {
            addCriterion(ICampusDAO.CampusType + " is null");
            return this;
        }
        public Criteria andCampusTypeIsNotNull() {
            addCriterion(ICampusDAO.CampusType + " is not null");
            return this;
        }
    
        public Criteria andCampusTypeIsNotEmpty() {        
            addCriterion(ICampusDAO.CampusType + " is not null AND " + ICampusDAO.CampusType + " <> ''");
            return this;
        }
    		
    	public Criteria andCampusTypeIsEmpty() {       
            addCriterion("(" + ICampusDAO.CampusType + " is null OR " + ICampusDAO.CampusType + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andCampusTypeEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusType + " = ", value, "campusType");
            return this;
        }
        
        public Criteria andCampusTypeEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusType);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTypeEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusType + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andCampusTypeNotEqualTo(String value) {
        	        
            addCriterion(ICampusDAO.CampusType + " <>", value, "campusType");
            return this;
        }
               
        public Criteria andCampusTypeNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICampusDAO.CampusType + " is null OR " + ICampusDAO.CampusType + " <>", value, "campusType");
            return this;
        }
        
        public Criteria andCampusTypeNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusType);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTypeNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusType + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusTypeGreaterThan(String value) {
        				
            addCriterion(ICampusDAO.CampusType + " >", value, "campusType");
            return this;
        }
        
        public Criteria andCampusTypeGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.CampusType);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTypeGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusType + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andCampusTypeGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusType + " >=", value, "campusType");
            return this;
        }
        
        public Criteria andCampusTypeGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusType);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTypeGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusType + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusTypeLessThan(String value) {
        				
            addCriterion(ICampusDAO.CampusType + " <", value, "campusType");
            return this;
        }
        
        public Criteria andCampusTypeLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusType);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTypeLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusType + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusTypeLessThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.CampusType + " <=", value, "campusType");
            return this;
        }
        
        public Criteria andCampusTypeLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.CampusType);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andCampusTypeLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusType + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andCampusTypeLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.CampusType + " like", buffer.toString(), "campusType");
            return this;
        }
        public Criteria andCampusTypeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.CampusType + " not like", buffer.toString(), "campusType");
            return this;
        }
                
                public Criteria andCampusTypeIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andCampusTypeEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.CampusType + " in", values, "campusType");
            	return this;
            }
        }
        public Criteria andCampusTypeNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andCampusTypeNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.CampusType + " not in", values, "campusType");
            	return this;
            }
        }
        
        public Criteria andCampusTypeIn(String[] values) {
        	
        	if(values.length == 1){
        		return andCampusTypeEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.CampusType + " in", Arrays.asList(values), "campusType");
            	return this;
            }
        }
        public Criteria andCampusTypeNotIn(String[] values) {
        	if(values.length == 1){
        		return andCampusTypeNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.CampusType + " not in", Arrays.asList(values), "campusType");
            	return this;
            }
        }
		
		public Criteria andCampusTypeIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusType + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andCampusTypeNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.CampusType + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andCampusTypeBetween(String value1, String value2) {
            addCriterion(ICampusDAO.CampusType + " between", value1, value2, "campusType");
            return this;
        }
        
                public Criteria andCampusTypeNotBetween(String value1, String value2) {
            addCriterion(ICampusDAO.CampusType + " not between", value1, value2, "campusType");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andSortIndexIsNull() {
            addCriterion(ICampusDAO.SortIndex + " is null");
            return this;
        }
        public Criteria andSortIndexIsNotNull() {
            addCriterion(ICampusDAO.SortIndex + " is not null");
            return this;
        }
    
        public Criteria andSortIndexIsNotEmpty() {        
            addCriterion(ICampusDAO.SortIndex + " is not null AND " + ICampusDAO.SortIndex + " <> ''");
            return this;
        }
    		
    	public Criteria andSortIndexIsEmpty() {       
            addCriterion("(" + ICampusDAO.SortIndex + " is null OR " + ICampusDAO.SortIndex + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andSortIndexEqualTo(long value) {
        	return andSortIndexEqualTo(Long.valueOf(value));
        }
               public Criteria andSortIndexEqualTo(java.lang.Long value) {
        				
            addCriterion(ICampusDAO.SortIndex + " = ", value, "sortIndex");
            return this;
        }
        
        public Criteria andSortIndexEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.SortIndex);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andSortIndexEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.SortIndex + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andSortIndexNotEqualTo(long value) {
        	return andSortIndexNotEqualTo(Long.valueOf(value));
        }
                public Criteria andSortIndexNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(ICampusDAO.SortIndex + " <>", value, "sortIndex");
            return this;
        }
               
        public Criteria andSortIndexNotEqualToOrIsNull(long value) {
        	return andSortIndexNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andSortIndexNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(ICampusDAO.SortIndex + " is null OR " + ICampusDAO.SortIndex + " <>", value, "sortIndex");
            return this;
        }
        
        public Criteria andSortIndexNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.SortIndex);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andSortIndexNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.SortIndex + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andSortIndexGreaterThan(long value) {
        	return andSortIndexGreaterThan(Long.valueOf(value));
        }
                public Criteria andSortIndexGreaterThan(java.lang.Long value) {
        				
            addCriterion(ICampusDAO.SortIndex + " >", value, "sortIndex");
            return this;
        }
        
        public Criteria andSortIndexGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.SortIndex);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andSortIndexGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.SortIndex + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andSortIndexGreaterThanOrEqualTo(long value) {
        	return andSortIndexGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andSortIndexGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICampusDAO.SortIndex + " >=", value, "sortIndex");
            return this;
        }
        
        public Criteria andSortIndexGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.SortIndex);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andSortIndexGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.SortIndex + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andSortIndexLessThan(long value) {
        	return andSortIndexLessThan(Long.valueOf(value));
        }
                public Criteria andSortIndexLessThan(java.lang.Long value) {
        				
            addCriterion(ICampusDAO.SortIndex + " <", value, "sortIndex");
            return this;
        }
        
        public Criteria andSortIndexLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.SortIndex);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andSortIndexLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.SortIndex + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andSortIndexLessThanOrEqualTo(long value) {
        	return andSortIndexLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andSortIndexLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(ICampusDAO.SortIndex + " <=", value, "sortIndex");
            return this;
        }
        
        public Criteria andSortIndexLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.SortIndex);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andSortIndexLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.SortIndex + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andSortIndexIn(long[] values) {
        	if(values.length == 1){
        		return andSortIndexEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.SortIndex + " in", values, "sortIndex");
            	return this;
            }
        }
        
        public Criteria andSortIndexNotIn(long[] values) {
        	if(values.length == 1){
        		return andSortIndexNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.SortIndex + " not in", values, "sortIndex");
            	return this;
            }
        }
        
                public Criteria andSortIndexIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andSortIndexEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.SortIndex + " in", values, "sortIndex");
            	return this;
            }
        }
        public Criteria andSortIndexNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andSortIndexNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.SortIndex + " not in", values, "sortIndex");
            	return this;
            }
        }
        
        public Criteria andSortIndexIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andSortIndexEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.SortIndex + " in", Arrays.asList(values), "sortIndex");
            	return this;
            }
        }
        public Criteria andSortIndexNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andSortIndexNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.SortIndex + " not in", Arrays.asList(values), "sortIndex");
            	return this;
            }
        }
		
		public Criteria andSortIndexIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.SortIndex + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andSortIndexNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.SortIndex + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andSortIndexBetween(long value1,long value2) {
        	addCriterion(ICampusDAO.SortIndex + " between", value1, value2, "sortIndex");
            return this;
        }
                public Criteria andSortIndexBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICampusDAO.SortIndex + " between", value1, value2, "sortIndex");
            return this;
        }
        
                
        public Criteria andSortIndexNotBetween(long value1,long value2) {
        	addCriterion(ICampusDAO.SortIndex + " not between", value1, value2, "sortIndex");
            return this;
        }
                public Criteria andSortIndexNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(ICampusDAO.SortIndex + " not between", value1, value2, "sortIndex");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andStatusIsNull() {
            addCriterion(ICampusDAO.Status + " is null");
            return this;
        }
        public Criteria andStatusIsNotNull() {
            addCriterion(ICampusDAO.Status + " is not null");
            return this;
        }
    
        public Criteria andStatusIsNotEmpty() {        
            addCriterion(ICampusDAO.Status + " is not null AND " + ICampusDAO.Status + " <> ''");
            return this;
        }
    		
    	public Criteria andStatusIsEmpty() {       
            addCriterion("(" + ICampusDAO.Status + " is null OR " + ICampusDAO.Status + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andStatusEqualTo(String value) {
        				
            addCriterion(ICampusDAO.Status + " = ", value, "status");
            return this;
        }
        
        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.Status);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Status + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andStatusNotEqualTo(String value) {
        	        
            addCriterion(ICampusDAO.Status + " <>", value, "status");
            return this;
        }
               
        public Criteria andStatusNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICampusDAO.Status + " is null OR " + ICampusDAO.Status + " <>", value, "status");
            return this;
        }
        
        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.Status);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Status + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andStatusGreaterThan(String value) {
        				
            addCriterion(ICampusDAO.Status + " >", value, "status");
            return this;
        }
        
        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.Status);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Status + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andStatusGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.Status + " >=", value, "status");
            return this;
        }
        
        public Criteria andStatusGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.Status);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Status + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusLessThan(String value) {
        				
            addCriterion(ICampusDAO.Status + " <", value, "status");
            return this;
        }
        
        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.Status);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Status + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusLessThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.Status + " <=", value, "status");
            return this;
        }
        
        public Criteria andStatusLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.Status);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Status + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andStatusLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.Status + " like", buffer.toString(), "status");
            return this;
        }
        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.Status + " not like", buffer.toString(), "status");
            return this;
        }
                
                public Criteria andStatusIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andStatusEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.Status + " in", values, "status");
            	return this;
            }
        }
        public Criteria andStatusNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andStatusNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.Status + " not in", values, "status");
            	return this;
            }
        }
        
        public Criteria andStatusIn(String[] values) {
        	
        	if(values.length == 1){
        		return andStatusEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.Status + " in", Arrays.asList(values), "status");
            	return this;
            }
        }
        public Criteria andStatusNotIn(String[] values) {
        	if(values.length == 1){
        		return andStatusNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.Status + " not in", Arrays.asList(values), "status");
            	return this;
            }
        }
		
		public Criteria andStatusIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Status + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Status + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(ICampusDAO.Status + " between", value1, value2, "status");
            return this;
        }
        
                public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(ICampusDAO.Status + " not between", value1, value2, "status");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andRemarksIsNull() {
            addCriterion(ICampusDAO.Remarks + " is null");
            return this;
        }
        public Criteria andRemarksIsNotNull() {
            addCriterion(ICampusDAO.Remarks + " is not null");
            return this;
        }
    
        public Criteria andRemarksIsNotEmpty() {        
            addCriterion(ICampusDAO.Remarks + " is not null AND " + ICampusDAO.Remarks + " <> ''");
            return this;
        }
    		
    	public Criteria andRemarksIsEmpty() {       
            addCriterion("(" + ICampusDAO.Remarks + " is null OR " + ICampusDAO.Remarks + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andRemarksEqualTo(String value) {
        				
            addCriterion(ICampusDAO.Remarks + " = ", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.Remarks);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Remarks + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andRemarksNotEqualTo(String value) {
        	        
            addCriterion(ICampusDAO.Remarks + " <>", value, "remarks");
            return this;
        }
               
        public Criteria andRemarksNotEqualToOrIsNull(String value) {
        	        
            addCriterion(ICampusDAO.Remarks + " is null OR " + ICampusDAO.Remarks + " <>", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.Remarks);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Remarks + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andRemarksGreaterThan(String value) {
        				
            addCriterion(ICampusDAO.Remarks + " >", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.Remarks);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Remarks + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andRemarksGreaterThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.Remarks + " >=", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.Remarks);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Remarks + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksLessThan(String value) {
        				
            addCriterion(ICampusDAO.Remarks + " <", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.Remarks);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Remarks + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksLessThanOrEqualTo(String value) {
        				
            addCriterion(ICampusDAO.Remarks + " <=", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.Remarks);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Remarks + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andRemarksLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.Remarks + " like", buffer.toString(), "remarks");
            return this;
        }
        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(ICampusDAO.Remarks + " not like", buffer.toString(), "remarks");
            return this;
        }
                
                public Criteria andRemarksIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andRemarksEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.Remarks + " in", values, "remarks");
            	return this;
            }
        }
        public Criteria andRemarksNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andRemarksNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.Remarks + " not in", values, "remarks");
            	return this;
            }
        }
        
        public Criteria andRemarksIn(String[] values) {
        	
        	if(values.length == 1){
        		return andRemarksEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.Remarks + " in", Arrays.asList(values), "remarks");
            	return this;
            }
        }
        public Criteria andRemarksNotIn(String[] values) {
        	if(values.length == 1){
        		return andRemarksNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.Remarks + " not in", Arrays.asList(values), "remarks");
            	return this;
            }
        }
		
		public Criteria andRemarksIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Remarks + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.Remarks + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(ICampusDAO.Remarks + " between", value1, value2, "remarks");
            return this;
        }
        
                public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(ICampusDAO.Remarks + " not between", value1, value2, "remarks");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andDeleteFlagIsNull() {
            addCriterion(ICampusDAO.DeleteFlag + " is null");
            return this;
        }
        public Criteria andDeleteFlagIsNotNull() {
            addCriterion(ICampusDAO.DeleteFlag + " is not null");
            return this;
        }
    
        public Criteria andDeleteFlagIsNotEmpty() {        
            addCriterion(ICampusDAO.DeleteFlag + " is not null AND " + ICampusDAO.DeleteFlag + " <> ''");
            return this;
        }
    		
    	public Criteria andDeleteFlagIsEmpty() {       
            addCriterion("(" + ICampusDAO.DeleteFlag + " is null OR " + ICampusDAO.DeleteFlag + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andDeleteFlagEqualTo(int value) {
        	return andDeleteFlagEqualTo(Integer.valueOf(value));
        }
               public Criteria andDeleteFlagEqualTo(java.lang.Integer value) {
        				
            addCriterion(ICampusDAO.DeleteFlag + " = ", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.DeleteFlag);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.DeleteFlag + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andDeleteFlagNotEqualTo(int value) {
        	return andDeleteFlagNotEqualTo(Integer.valueOf(value));
        }
                public Criteria andDeleteFlagNotEqualTo(java.lang.Integer value) {
        	        
            addCriterion(ICampusDAO.DeleteFlag + " <>", value, "deleteFlag");
            return this;
        }
               
        public Criteria andDeleteFlagNotEqualToOrIsNull(int value) {
        	return andDeleteFlagNotEqualToOrIsNull(Integer.valueOf(value));
        }
                
        public Criteria andDeleteFlagNotEqualToOrIsNull(java.lang.Integer value) {
        	        
            addCriterion(ICampusDAO.DeleteFlag + " is null OR " + ICampusDAO.DeleteFlag + " <>", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.DeleteFlag);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.DeleteFlag + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andDeleteFlagGreaterThan(int value) {
        	return andDeleteFlagGreaterThan(Integer.valueOf(value));
        }
                public Criteria andDeleteFlagGreaterThan(java.lang.Integer value) {
        				
            addCriterion(ICampusDAO.DeleteFlag + " >", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(ICampusDAO.DeleteFlag);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.DeleteFlag + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andDeleteFlagGreaterThanOrEqualTo(int value) {
        	return andDeleteFlagGreaterThanOrEqualTo(Integer.valueOf(value));
        }
                public Criteria andDeleteFlagGreaterThanOrEqualTo(java.lang.Integer value) {
        				
            addCriterion(ICampusDAO.DeleteFlag + " >=", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.DeleteFlag);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.DeleteFlag + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagLessThan(int value) {
        	return andDeleteFlagLessThan(Integer.valueOf(value));
        }
                public Criteria andDeleteFlagLessThan(java.lang.Integer value) {
        				
            addCriterion(ICampusDAO.DeleteFlag + " <", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.DeleteFlag);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.DeleteFlag + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagLessThanOrEqualTo(int value) {
        	return andDeleteFlagLessThanOrEqualTo(Integer.valueOf(value));
        }
                public Criteria andDeleteFlagLessThanOrEqualTo(java.lang.Integer value) {
        				
            addCriterion(ICampusDAO.DeleteFlag + " <=", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(ICampusDAO.DeleteFlag);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.DeleteFlag + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andDeleteFlagIn(int[] values) {
        	if(values.length == 1){
        		return andDeleteFlagEqualTo((java.lang.Integer)values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.DeleteFlag + " in", values, "deleteFlag");
            	return this;
            }
        }
        
        public Criteria andDeleteFlagNotIn(int[] values) {
        	if(values.length == 1){
        		return andDeleteFlagNotEqualTo((java.lang.Integer)values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.DeleteFlag + " not in", values, "deleteFlag");
            	return this;
            }
        }
        
                public Criteria andDeleteFlagIn(List<java.lang.Integer> values) {
        	
        	if(values.size() == 1){
        		return andDeleteFlagEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.DeleteFlag + " in", values, "deleteFlag");
            	return this;
            }
        }
        public Criteria andDeleteFlagNotIn(List<java.lang.Integer> values) {
        	if(values.size() == 1){
        		return andDeleteFlagNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(ICampusDAO.DeleteFlag + " not in", values, "deleteFlag");
            	return this;
            }
        }
        
        public Criteria andDeleteFlagIn(java.lang.Integer[] values) {
        	
        	if(values.length == 1){
        		return andDeleteFlagEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.DeleteFlag + " in", Arrays.asList(values), "deleteFlag");
            	return this;
            }
        }
        public Criteria andDeleteFlagNotIn(java.lang.Integer[] values) {
        	if(values.length == 1){
        		return andDeleteFlagNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(ICampusDAO.DeleteFlag + " not in", Arrays.asList(values), "deleteFlag");
            	return this;
            }
        }
		
		public Criteria andDeleteFlagIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.DeleteFlag + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andDeleteFlagNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(ICampusDAO.DeleteFlag + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagBetween(int value1,int value2) {
        	addCriterion(ICampusDAO.DeleteFlag + " between", value1, value2, "deleteFlag");
            return this;
        }
                public Criteria andDeleteFlagBetween(java.lang.Integer value1, java.lang.Integer value2) {
            addCriterion(ICampusDAO.DeleteFlag + " between", value1, value2, "deleteFlag");
            return this;
        }
        
                
        public Criteria andDeleteFlagNotBetween(int value1,int value2) {
        	addCriterion(ICampusDAO.DeleteFlag + " not between", value1, value2, "deleteFlag");
            return this;
        }
                public Criteria andDeleteFlagNotBetween(java.lang.Integer value1, java.lang.Integer value2) {
            addCriterion(ICampusDAO.DeleteFlag + " not between", value1, value2, "deleteFlag");
            return this;
        }
        
            	
    	    	
    	        
        
    }
	
    
}